EDS 213 Discussion 1


Spring Quarter

Discussion section overview

The goal of our weekly discussion sections will be to answer an analytical question of your choosing using a database. You will create this database yourself, and then use it to answer your question.

Schedule

Week Objective
1 Select a dataset and understand the relationships among the different tables to define a schema. You can pick a dataset(s) from this list, or find your own!
2 Clean the data.
3 Ingest the data into a database and explore your newly created database.
4 After cleaning your data and having it in a database, come up with an analytical question to answer with your database.Develop the SQL query/ queries to answer this question.
5 Write some R or Python code to create some data visualization/ analysis with your database.
6 Document your work.
7 Database showcase!